Computer Science for IGCSE & O level - Databases (Section 6 - No. 15)
What is the purpose of the 'WHERE' clause in an SQL query?
To specify the tables from which to retrieve data.
To define the order in which the results are displayed.
To filter the results based on specified criteria.
To group the results by a specific column.
Explication
The WHERE clause filters the results based on specific conditions, allowing you to retrieve only the desired records.